Calculate days to the end of the previous month

[sarah372]

Looking to calculate the days from B2 to the end of the previous month which will make it 30 sept, this will have to change as the the months do, as cell D1 is a Today function



Thanks
Sarah372

 

[NARAYANK991]

Hi Sarah ,

See your file.

Narayan

 

[sarah372]

Thanks Narayan,
very helpful will input it and see how it goes

Thanks again
Sarah

 

[Hui]

D2: =EOMONTH(D$1,-1)-B2
Copy down

 

[sarah372]

thanks Hui for your help

sarah