Thread
:
calculating dates
View Single Post
#
4
Posted to microsoft.public.excel.misc
smartin
external usenet poster
Posts: 915
calculating dates
Sheeloo wrote:
Try this in B1
=C1-MOD(C1-A1,365.25)+1
That will be off by one day in many circumstances. Try it with A1 =
2004/03/01 and today's date in C1.
Reply With Quote
smartin
View Public Profile
Find all posts by smartin