Thread: Returning a month on a spreadsheet

Hello All

im struggling to solve this and would appreciate any help you can give me

Please refer to the attached spreadsheet

Basically what I am trying to do is if Someone puts the long month in Cell A1 ie January as apposed to Jan in A19 I want to return YTD Jan and not YTD January

I have tried to do this as a lookup in column C to get the short month but have a number of errors

1 if I put short date in a1 column c comes back #NA
2 in A19 how can I make this say YTD Jan - if someone puts in Jan or January in A1

I need A19 to say shortend month as the data base im reading from does not like long month and im trying to automate a report for non use excel readers so they in case they input long one it automatcally returns short date for me

thanks
bumbty blue