Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'd like to create a formula in Excel that will calculate my products expiration date. Obviously, I'll know the manufacturing date that can be a calendar date in the form of : dd/mm/yy or julian date. The julian date would be 2310 w/ 2 representing the last digit of the year(2012) and 310 representing 11/5/12. My expiration date calculation will be either adding 330 or 150 to the calendar date or julian date. Help!
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculat an expiration date | Excel Worksheet Functions | |||
Dealing with date formats on expiration date | Excel Programming | |||
Conditional Format for a date 1 month before Expiration in Excel 2 | Excel Worksheet Functions | |||
How do I create an alert of expiration date in Excel? | Excel Discussion (Misc queries) | |||
Code For Expiration Date | Excel Programming |