formula to display anniversary date

  • Thread starter Thread starter Guest
  • Start date Start date
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

assuming that date is in A1

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

assuming that date is in A1



--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
THANKS SO VERY MUCH........IT WORKED

Bob Phillips said:
=DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))

assuming that date is in A1



--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
The death of music TV channels in UK - but not Europe? 4
Lookup closest to 5
How to get Holidays in cell/s? (Find explaination in details) 3
If statements?? 2
Happy Anniversary Flag? 4
Sorting amounts in columns by due dates 7
names dates & amounts stated multiple times in document 0

Back
Top