Hi there - thanks in advance for your help - this is giving me a headache.
Basically I want to use the Year function to extract a Year from a date (if the cell isn't empty)
This works:
=IF(F14=0,"",YEAR(F14)) However I would like to then add 5 years onto the result.
I have attached the formulas I have used for each cell and highlight in red the one I need looking at.
Thanks
=if(a2=0,"",year(a2)+5)
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks - I tried that but it didn't work - then noticed the cell type was date and not general. So annoying lol
Thank you
Cell C2 formula , Copy and drag right
HTML Code:
im not sure what you are expecting because it works very well when the format is general.Screen Shot 2021-08-25 at 8.12.59 am.png
C2 formula, copy or drag to fill the range:
Formula:
Please Login or Register to view this content.
Row row row your boat
Gently down the stream
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks